package com.cooper.dao.general;

import java.util.List;

import net.paoding.rose.jade.annotation.DAO;
import net.paoding.rose.jade.annotation.Insert;
import net.paoding.rose.jade.annotation.ReturnGeneratedKeys;
import net.paoding.rose.jade.annotation.SQL;

import com.cooper.entity.AdviceReplyEntity;

@DAO
public interface AdviceReplyDAO {
	
	static final String TABLE_NAME = "d_advice_reply";
	
	@ReturnGeneratedKeys
	@Insert(tableName=TABLE_NAME)
	Long saveEntity(AdviceReplyEntity entity) throws Exception;

	@SQL("select * from d_advice_reply where deleted='n' and subject_id=:1 order by id asc")
	List<AdviceReplyEntity> getReplyList(long subjectId);
	
}
